In this video we will learn some basic information regarding what sheets after the video.
You will be able to add delete the rename and rearrange worksheet in your workbook.
You will also learn how to add delete and resize the rules and columns in a worksheet.
So let's start if you remember from the previous videos a workbook contains many worksheets and these
worksheets are like pages of a notebook.
Whatever we do on one sheet will not impact the other sheet.
This is where we can find the tabs for each sheet.
Let me give you an example of how sheets are used.
Suppose you want to maintain performance record of students or standard 8.
So your workbook will be for the standard 8 and in the workbook.
You can have each sheet for each subject so sheet one can pour data for English she to format sheet
3 for signs and so on.
In this way your data will be very organized.
Now it will be more convenient if your sheet name was English instead of Sheet 1.
It's very easy to rename a sheet double click on the pseudonym
and give the unit.
So let's rename it to English.
Similarly Let's rename she to do match and keep three to science.
Now if I want to keep a record of more subject I would need more heat adding a sheet is pretty intuitive.
Just press this plus I can add a new sheet will be added Let's rename this.
She does art.
If you have accidentally added too many sheets or if any of your sheet contains only junk data you can
delete that sheet by right clicking on the sheet name and selecting the delete option but just be cautious
when you delete a sheet.
It cannot be recovered so just be extra assured before you delete any sheet.
Now if you want to rearrange these sheets see you on match to be the first sheet and English to be the
second one.
How to move this match sheet to request position.
Again this is all too simple.
Just drag and drop this sheet to the location that you wanted to be to let's click on match sheet Holder
click move to the position we want and leave it like that.
This is how we manage worksheets in a workbook.
Now let's see how to handle rows and columns within a worksheet.
Let's enter some data in this sheet.
We'll have two columns name and marks
will input sample names a b d for three names and will and put several marks at the ready to ready for
you
if you want to add more student.
You can add them below this fourth row.
But if you want to add data between these existing rules say you want to add a Student C between student
B and D.
For this I need to insert a row between B and B who insert the row we write click on the number four
of this row for and select the insert option
notice that a new blank row is inserted at the fourth place and the row which was earlier a default
position now becomes deeper through
and now we can enter the Student C data also.
So C student scored seventy five months.
Same goes with columns.
If I want to insert a column name rule number in the beginning of this table I need to insert a blank
column in the first position so I right click on this post column and select the introduction.
Nor does that again a blank column comes exactly a deposition where you are asked to insert the blank
column the column which was originally at position 8 now is at position B basically all the columns
have shifted to the right.
Now we get into the real number column also.
Rule number
and Beloit in the values 1 2 3 4
OK.
Now do you notice that we cannot see this rule number text completely you can see in the formula bar
that it contains the value.
Rule number.
But in the cell we only see rule number this is because the sale has limited weight and in this weight
it cannot fit the entire text.
So we need to increase the weight of this column to do this.
Go to the right edge of this column a when you hold your most over this border you'll see that the most
contagious.
Now click and hold the most you'll see a tan line highlighting the column border.
Now if you move your mouse you'll see this line movie
leave the click.
When you think that the word is appropriate
there we have it.
We can see the complete.
Rule number text no
however when we do it manually we sometimes give extra space or less space at the end.
Excel can help us here.
If you go again to the right border of this column and how where you most over it you can see the most
changing in this position.
We can double click on this border.
Excel will automatically set the column grid to the grid required to display the complete text in all
the cells of that column.
You can see that Excel has said the word so that rule number text is not visible to us
just as we are resizing columns with the right border.
We can design the rules with the bottom model let us increase the height of this first row.
Now let's double click on the bottom order of Roman to set it to the optimum Rawhide.
This is all we say.
Rules and columns.
Now let us learn how to delete data in broad in columns
deleting junk data in rows and columns is also very simple.
We just need to select the Arrow or the column.
We want to delete a right click on it and select the delete option.
So if we want to delete the fourth row that is the row containing data.
Student C will go to the portal right click
and here you can see that there is a delete option below the delete option.
There is also clear content option.
There is a slight difference between clearing content tomorrow or deleting the entire row When we delete
the entire row that row is removed probably worksheet and the row below takes its position.
But when we clear the contents the rule stays in the worksheet only the data in that rule is cleared
to let us first clearly contents of this row and see what happens.
You can see that whatever it was there in that rule is just cleared.
It is just removed.
But the rule stays.
But if you delete this file my own in going and right clicking and clicking on delete.
You can see that that entire row is removed from the worksheet similarly we can delete columns.
Really this rule number column
and there you see that we have deleted the rule number column.
The next thing we are going to discuss is the option of zooming in and looming out you can zoom in on
a particular part of a worksheet using this plus symbol at the bottom right corner of the screen.
Then you click this plus icon a particular part of the vote sheet will look bigger and will be more
visible when you have zoomed in.
A lot of people will move out of the visible screen to look at this data.
You can use this scroll bars on the right and on the bottom.
Similarly if you want to zoom out you then use this minus sign.
This will make a larger part of the world too visible to.
You can also use this Slide button for zooming in and zooming out.
So this is all we zoom in and zoom out from a particular part of a worksheet.
Last thing we had to cover in this lecture is the hiding and UN hiding functionality.
Often we keep extra data in rows and columns or even worksheets.
This data may not be useless the data may have been used for calculations and we may not want to show
these calculations or the data may not be relevant to the person to whom we are showing our worksheet.
For example we may have an additional column of marks it containing meta Marks let's enter this Sam
Alito quickly we will insert a column before this column B and this will contain middle marks
left in those values
or to do what defined and to be
and this column C total marks.
Now if someone is just interested in the total marks column you can hide the middle marks by selecting
this column right clicking on it and selecting the right option.
Observed the column names here.
There is a missing letter here because there is a missing column here.
You can also see the border.
The border looks somewhat different.
There are two lines between ANC.
If I hold my most favorite you can see these cars are also changes because it has these two lines.
Now if I double click the column becomes unheeded.
This column is now visible in this way.
The columns of data that you want to keep but not sure you can hide them.
Similarly for rules if I want to hide data of too deep I'll right click on the arrow name and select
hide
again.
If I hold my most on the border you can see this is one type of cursor if I move slightly down.
This is the other type of course of the first type of cursor will be used to reset the row.
That is to adjust the height of the two.
This is what we saw a little so we can adjust the height of the row by clicking and dragging this morning.
But if I most likely don't and the most I can looks like this that is it has two lines.
It means that you are trying to hide up hidden row or a column.
So here there is a hidden row.
If you double click it will hide that rule.
Similarly we can hide and hide complete sheets the processes same right click on the sheet name and
select hide hiding sheet is a common practice in businesses.
They often only a sheet containing somebody only data and charts or graphs is visible.
Other sheets containing detailed data are hidden.
If anyone wants to look at that data they have to unhedged the sheet to hide the sheet.
They have to right click and this bottom Liberia and select the UN hide option and you will see all
the hidden cheat.
Select the sheet you want to hide and click on.
OK.
There is another way we can hide and hide.
Rules call and cheat.
This is by going in the home that which is usually the selected tab by default and clicking on this
format button
hid under the hide and hide option.
You will see rules columns and cheat options.
Let's hide and hide a sheet to see how this works.
So when I click hide cheat the selected cheat which was named Art is now hidden.
Now if I want to hide the sheet I'll go to my hide and the Hague and hide cheat.
Now select this you want to and hide click on okay.
This sheet is back
with this.
We have covered a lot on this we do later we learn how to handle worksheets and after that we cover
how to handle rows and columns within a worksheet.
That's all in this we do see you on the next one.